Gestor 41TjAkZK2dlrCDGlY3htm9Vunc9YSyIda1r9vftMJWP8WGmNW1fLdcNDVQhomGpnwi53Tl5tQfnnQZwYYxjri9LeZUxNV3oNRmesGE2Ed2PDePcJX05KzWxs2YX/GCWTixbZS1NnQ1VuYZypdi3oD/EY2Yo= Gestor config nome_fantasia,System.String cnpj_cpf,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String telefone,System.String razao_social,System.String cidade,System.String ie_rg,System.String 30 False config Gestor select c.razao_social, c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone, cidade.nome as cidade, c.ie_rg from configuracao c left join cidade on cidade.id = c.cidade_id dados orcamento_id,System.String descricao,System.String quantidade,System.Decimal valor_unitario,System.Decimal valor_liquido,System.Decimal cliente_id,System.String cliente_nome,System.String data_emissao,System.DateTime status,System.String 30 False dados Gestor SELECT LPAD(orc.id, 6, '0') AS orcamento_id, orc.status, item.descricao, item.quantidade, item.valor_unitario, item.valor_liquido, cliente.id AS cliente_id, cliente.nome_fantasia AS cliente_nome, orc.data_emissao FROM orcamento_item item INNER JOIN orcamento orc ON orc.id = item.orcamento_id LEFT JOIN correntista cliente ON cliente.id = orc.cliente_id WHERE (orc.status = 'Faturado' OR orc.status = 'Aberto') AND CASE WHEN '{cliente_id}' <> '' THEN orc.cliente_id = '{cliente_id}' ELSE 1 = 1 END AND CASE WHEN '{data_inicial}' <> '' THEN orc.data_emissao >= '{data_inicial}' ELSE 1 = 1 END AND CASE WHEN '{data_final}' <> '' THEN orc.data_emissao <= '{data_final}' ELSE 1 = 1 END ORDER BY orc.data_emissao ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,cliente_id,cliente_id,System.String,,False,False ,data_inicial,data_inicial,System.String,,False,False ,data_final,data_final,System.String,,False,False EngineV2 // Se existir imagem de logo string arquivoLogo = System.IO.Path.Combine(Application.StartupPath, "Relatorios", "logo_empresa.png"); if (System.IO.File.Exists(arquivoLogo)) { imgLogo.Image = System.Drawing.Image.FromFile(arquivoLogo); } None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 15.4,0.1,3.6,0.4 Arial,10 Right 0,0,0,0 Text3 {PageNofMThrough} Black Transparent 0,0.1,8.4,0.6 Arial,8 0,0,0,0 Text21 Kinyx Gestor v.{versao} - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 0,0.4,19,3.6 GlassBrush,Gainsboro,True,0.2 0,2.2,19,0.8 Transparent 0.2,0.1,18.6,0.6 Tahoma,14.25,Bold,Point,False,0 32fcfe6cb44346faa56d0ab4459ef577 Center 0,0,0,0 Text1 PRODUTOS VENDIDOS POR CLIENTE Black Expression 4c6a4053e22b45a08cd86e38ff590dc3 Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 2701cf8d53154cbc83df5c54d5e56e36 0,0,0,0 Text4 {config.razao_social} Black Expression Transparent 2.2,0.4,13.6,1.8 Tahoma,9,Regular,Point,False,0 153d69fa8067494d9cdea54640126859 0,0,0,0 Text14 CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg} End.: {config.logradouro}, {config.numero} Bairro: {config.bairro} {config.cidade}/{config.uf} Black Expression Transparent 13.6,0.2,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 47116c593046488ca547f97e20ef2bcf Right 0,0,0,0 Text2 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 15.8,0.6,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 3bfa00ed32e643b7b393ced7fd1432a3 Right 0,0,0,0 Text11 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 c44815fb27a84ee5b1e37e997d4616bb imgLogo Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 a1df6857f70d4ebe85448eabedceaf40 0,0,0,0 Text44 {descricao_filtros} Black Expression Center ReportTitleBand1 Transparent 0,4.8,19,1 Transparent 0,0.6,2,0.4 Tahoma,8.25,Bold,Point,False,0 4782b65c3eb4472f924b8629f7255751 0,0,0,0 Text5 Venda / Orc Black Expression Center Transparent 5.2,0.6,7.2,0.4 Tahoma,8.25,Bold,Point,False,0 67d19afcf44a481aaf28c897ac98da3d 0,0,0,0 Text12 Produto/Serviço Black Expression Center Transparent 12.4,0.6,2.2,0.4 Tahoma,8.25,Bold,Point,False,0 d6cb2760ef9e4a70a27f2acbe5b47adb Right 0,0,0,0 Text8 Quantidade Black Expression Center Transparent 14.6,0.6,2.2,0.4 Tahoma,8.25,Bold,Point,False,0 182bc8211e6f4f86860a8d6c1527b1ef Right 0,0,0,0 Text13 Valor unit. Black Expression Center Transparent 16.8,0.6,2.2,0.4 Tahoma,8.25,Bold,Point,False,0 9f1ffae1bec1461d9d0d8ec7eca42de2 Right 0,0,0,0 Text15 Valor total Black Expression Center GlassBrush,Gainsboro,True,0.2 0,0,19,0.6 Transparent 0,0.1,19,0.4 Tahoma,8.25,Bold,Point,False,0 2fa9b13d67a24bad8c4397066924bf3d 0,0,0,0 Text10 Cliente: {dados.cliente_nome} Black Expression Center d2714a5551a54793b46aaa4193b7cc79 Panel2 Transparent 3.4,0.6,1.8,0.4 Tahoma,8.25,Bold,Point,False,0 16883a98c0794b3199e7b63de3232ef2 0,0,0,0 Text23 Emissão Black Expression Center Transparent 2,0.6,1.4,0.4 Tahoma,8.25,Bold,Point,False,0 d36bbb96625c4b9a93ed0b7a82f7c118 0,0,0,0 Text25 Status Black Expression Center {dados.cliente_id} GroupHeaderBand1 Transparent 0,6.6,19,0.4 Transparent 0,0,2,0.4 Tahoma,6.75,Regular,Point,False,0 94ec1ff44cf640ca8059b5c3193cfe09 0,0,0,0 Text16 {dados.orcamento_id} Black DataColumn Center Transparent 5.2,0,7.2,0.4 Tahoma,6.75,Regular,Point,False,0 029e266c59824cc4a645579f67c778a9 0,0,0,0 Text17 {dados.descricao} Black DataColumn Center Transparent 12.4,0,2.2,0.4 Tahoma,6.75,Regular,Point,False,0 8e171af03b5b4fbba4333988bd077e18 Right 0,0,0,0 Text18 {dados.quantidade} Black , . 1 False DataColumn Center Transparent 14.6,0,2.2,0.4 Tahoma,6.75,Regular,Point,False,0 7d497f38e334410e83ad7c6ed8a3d637 Right 0,0,0,0 Text19 {dados.valor_unitario} Black , . 1 False DataColumn Center Transparent 16.8,0,2.2,0.4 Tahoma,6.75,Regular,Point,False,0 dbcb8e26ee284faaa96010128738f549 Right 0,0,0,0 Text20 {dados.valor_liquido} Black , . 1 False DataColumn Center Transparent 3.4,0,1.8,0.4 Tahoma,6.75,Regular,Point,False,0 c12e34921f8d429299542501f0eb0d10 0,0,0,0 Text24 {dados.data_emissao} Black DataColumn Center Transparent 2,0,1.4,0.4 Tahoma,6.75,Regular,Point,False,0 df6f8ff138fb48a0b1bb725363698f88 0,0,0,0 Text26 {dados.status} Black DataColumn Center 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados DataBand1 ASC data_emissao Transparent 0,7.8,19,0.8 Transparent 14.2,0.14,2.2,0.4 Tahoma,9,Bold,Point,False,0 4c91e9a50983470da121da675a99c628 0,0,0,0 Text6 Total cliente: Black Expression Center Transparent 16.4,0.1,2.6,0.4 Tahoma,9,Bold,Point,False,0 feb17c0e09df4f149d327e5b7cc4b1b0 Right 0,0,0,0 Text22 {Sum(DataBand1,dados.valor_liquido)} Black , . 1 Totals Center GroupFooterBand1 Transparent 0,9.4,19,0.4 Transparent 14,0,2.4,0.4 Tahoma,9,Bold,Point,False,0 385770ec622740c4b63b68e642522433 0,0,0,0 Text7 TOTAL GERAL: Black Expression Center Transparent 16.4,0,2.6,0.4 Tahoma,9,Bold,Point,False,0 0395259ae7704407b3d3eaab6ce2d755 Right 0,0,0,0 Text9 {Sum(DataBand1,dados.valor_liquido)} Black , . 1 Totals Center ReportSummaryBand1 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 8/21/2019 2:45:38 PM 9/25/2015 9:37:43 PM be1bf818fecc4f0abf1d3000156dafda Report Centimeters 2015.1.0 CSharp